Sir Cavintek Software online test  interview questions

1)write a SQL query to get 3rd maximum salary in employees table?

2)Advantages and disadvantages of stored procedure?

3)write a SQL query to get last ID from table without using max?

4)difference between dynamic SQL and static SQL?

5)how dynamic SQL will be executed?

6)write a SQL query to delete all duplicate records in a table?

7)already we have students table with 7rows having identity column if client wants to insert a new record of student in a table of student ID is it possible?how?if it's not possible why?

8)how to concatenate two tables employee_name and employee_salary and the output should be displayed as (Mano;Dinesh)

9)Main difference between SQL and Plsql